home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Arsenal Files 6
/
The Arsenal Files 6 (Arsenal Computer).ISO
/
bbslists
/
bbdc0296.zip
/
DATAFORM.ATS
< prev
next >
Wrap
Text File
|
1995-01-20
|
6KB
|
133 lines
Format of BBS.ALL file for those wanting to do a conversion or
write a custom program.
Look for BBSPRC*.ZIP on a local BBS and see if it already
does what you want.
This unusual format was developed to cover several bases, Fixed Length
Databases, Comma delimited, and ability to sort without modification.
DATABASE USERS:
Import data as comma delimited and map field lengths.
SPREADSHEET USERS:
Import as comma delimited.
QUICKBASIC/VISUALBASIC/PDS:
Use the INPUT or LINE INPUT and RTRIM for variable length.
Use the TYPE record structure on the next page
to remove the quotes and return fixed length fields.
DESCRIPTION OF INPUT DATA (BBS.ALL):
ALL DATA TYPES ARE FIXED LENGTH STRINGS.
ALL FIELDS ARE QUOTE-COMMA DELIMITED.
ALL RECORDS ARE CARRIAGE RETURN LINE FEED DELIMITED.
DESCRIPTION SIZE IN BBS.ALL FILE OFFSET,LENGTH
RECORD NUMBER -------------- 004 0,4
BBS NAME ------------------- 032 8,32
SYSOP ---------------------- 031 43,31
PHONE ---------------------- 014 77,14
DATE VERIFIED -------------- 008 Last Connected to 94,8
TIME VERIFIED -------------- 008 Last Connected to 105,11
NEW ------------------------ 002 (No = 0, Yes = -1) 119,2
CHANGED # ------------------ 002 (No = 0, Yes = -1) 124,2
DOWN ----------------------- 002 (No = 0, Yes = -1) 129,2
DISCONNECTED --------------- 002 (No = 0, Yes = -1) 134,2
SUPPORT -------------------- 002 (No = 0, Yes = -1) 139,2
NON-METRO MD --------------- 002 (No = 0, Yes = -1) 144,2
NON-METRO VA --------------- 002 (No = 0, Yes = -1) 149,2
PAY BOARD ------------------ 002 (Free = 0, Pay = -1) 154,2
PRIVATE -------------------- 002 (Public = 0, Private = -1) 159,2
LOCATION ------------------- 025 City 164,25
BBS SOFTWARE --------------- 010 192,10
MIN SPEED ------------------ 004 Baud 205,4
MAX SPEED ------------------ 005 Baud 212,5
HARD DRIVE ----------------- 010 Storage 220,10
NODES ---------------------- 004 Phone Lines 233,4
CONFERENCES ---------------- 005 240,5
DOORS ---------------------- 004 248,4
CD'S ON LINE --------------- 003 255,3
CHAT ----------------------- 002 (No = 0, Yes = -1) 261,2
DESCRIPTION 1 -------------- 074 266,74
DESCRIPTION 2 -------------- 074 343,74
DESCRIPTION 3 -------------- 074 420,74
DESCRIPTION 4 -------------- 074 497,74
DESCRIPTION 5 -------------- 074 574,74
DESCRIPTION 6 -------------- 074 651,74
DESCRIPTION 7 -------------- 074 728,74
TOTAL RECORD SIZE=805
TYPE Test 'this is the record layout for a BBS listing
OpenQuote1 AS STRING * 1
RecordNumber AS STRING * 4
CloseQuoteCommaOpenQuote1 AS STRING * 3
BBSName AS STRING * 32
CloseQuoteCommaOpenQuote2 AS STRING * 3
Sysop AS STRING * 31
CloseQuoteCommaOpenQuote3 AS STRING * 3
Phone AS STRING * 14
CloseQuoteCommaOpenQuote4 AS STRING * 3
DateV AS STRING * 8
CloseQuoteCommaOpenQuote5 AS STRING * 3
TimeV AS STRING * 11
CloseQuoteCommaOpenQuote6 AS STRING * 3
NewBBS AS STRING * 2
CloseQuoteCommaOpenQuote7 AS STRING * 3
Changed AS STRING * 2
CloseQuoteCommaOpenQuote8 AS STRING * 3
Down AS STRING * 2
CloseQuoteCommaOpenQuote9 AS STRING * 3
Disconnected AS STRING * 2
CloseQuoteCommaOpenQuote10 AS STRING * 3
Support AS STRING * 2
CloseQuoteCommaOpenQuote11 AS STRING * 3
NonMetroMD AS STRING * 2
CloseQuoteCommaOpenQuote12 AS STRING * 3
NonMetroVA AS STRING * 2
CloseQuoteCommaOpenQuote13 AS STRING * 3
PayBoard AS STRING * 2
CloseQuoteCommaOpenQuote14 AS STRING * 3
Private AS STRING * 2
CloseQuoteCommaOpenQuote15 AS STRING * 3
Location AS STRING * 25
CloseQuoteCommaOpenQuote16 AS STRING * 3
BBSSoftware AS STRING * 10
CloseQuoteCommaOpenQuote17 AS STRING * 3
MinSpeed AS STRING * 4
CloseQuoteCommaOpenQuote20 AS STRING * 3
MaxSpeed AS STRING * 5
CloseQuoteCommaOpenQuote21 AS STRING * 3
HardDrive AS STRING * 10
CloseQuoteCommaOpenQuote22 AS STRING * 3
Nodes AS STRING * 4
CloseQuoteCommaOpenQuote23 AS STRING * 3
Conferences AS STRING * 5
CloseQuoteCommaOpenQuote24 AS STRING * 3
Doors AS STRING * 4
CloseQuoteCommaOpenQuote25 AS STRING * 3
CDsOnline AS STRING * 4
CloseQuoteCommaOpenQuote26 AS STRING * 3
Chat AS STRING * 2
CloseQuoteCommaOpenQuote27 AS STRING * 3
Description1 AS STRING * 74
CloseQuoteCommaOpenQuote28 AS STRING * 3
Description2 AS STRING * 74
CloseQuoteCommaOpenQuote29 AS STRING * 3
Description3 AS STRING * 74
CloseQuoteCommaOpenQuote30 AS STRING * 3
Description4 AS STRING * 74
CloseQuoteCommaOpenQuote31 AS STRING * 3
Description5 AS STRING * 74
CloseQuoteCommaOpenQuote32 AS STRING * 3
Description6 AS STRING * 74
CloseQuoteCommaOpenQuote33 AS STRING * 3
Description7 AS STRING * 74
CloseQuote1 AS STRING * 1
CarriageReturnLineFeed AS STRING * 1
END TYPE